Release 10.1A: OpenEdge Data Management:
SQL Development

Using Data Definition Language statements

DDL statements are used to add, modify, or remove database objects. The DDL is integral to creating and maintaining a database. For detailed information on database creation and administration, see OpenEdge Data Management: Database Administration .

This section covers the following information:

Working with tables
Working with indexes
Working with views
Note: When creating a table, view, or index in the SQL engine, choose table, view, index, and column names that are not SQL keywords. This is enforced by the SQL engine. However, if you are creating objects in the PUB schema using the SQL engine, you also must avoid using 4GL reserved keywords, such as DISPLAY. This is not enforced by the SQL engine. For a complete list of Progress 4GL keywords, see OpenEdge Data Management: SQL Reference .